CREATE TABLE [dbo].[TDPARA_PRUS]
(
[CO_USUA] [dbo].[TD_VC_008] NOT NULL,
[CO_SIST] [dbo].[TD_VC_008] NOT NULL,
[CO_MODU] [dbo].[TD_VC_008] NOT NULL,
[CO_MENU] [dbo].[TD_VC_020] NOT NULL,
[CO_ATRI] [dbo].[TD_VC_020] NOT NULL,
[CO_VALO] [dbo].[TD_VC_020] NOT NULL,
[NU_CORR_ATRI] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TDPARA_PR__NU_CO__25869641] DEFAULT ((0)),
[DE_VALO] [dbo].[TD_VC_050] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TDPARA_PR__CO_US__267ABA7A] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TDPARA_PR__FE_US__276EDEB3] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TDPARA_PR__CO_US__286302EC] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TDPARA_PR__FE_US__29572725] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDPARA_PRUS] ADD CONSTRAINT [PK__TDPARA_P__236C345260C757A0] PRIMARY KEY CLUSTERED  ([CO_USUA], [CO_SIST], [CO_MODU], [CO_MENU], [CO_ATRI], [CO_VALO], [NU_CORR_ATRI]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDPARA_PRUS] ADD CONSTRAINT [FK__TDPARA_PRUS__226010D3] FOREIGN KEY ([CO_USUA], [CO_SIST], [CO_MODU], [CO_MENU], [CO_ATRI], [NU_CORR_ATRI]) REFERENCES [dbo].[TTPARA_PRUS] ([CO_USUA], [CO_SIST], [CO_MODU], [CO_MENU], [CO_ATRI], [NU_CORR_ATRI])
GO
GRANT SELECT ON  [dbo].[TDPARA_PRUS] TO [public]
GRANT INSERT ON  [dbo].[TDPARA_PRUS] TO [public]
GRANT DELETE ON  [dbo].[TDPARA_PRUS] TO [public]
GRANT UPDATE ON  [dbo].[TDPARA_PRUS] TO [public]
GO
